package com.ruoyi.system.mapper;

import java.util.List;
import java.util.Map;

import com.ruoyi.system.domain.SysCusService1Bi;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * SysCusService1BiMapper接口
 * 
 * @author SYF
 * @date 2025-06-04
 */
public interface SysCusService1BiMapper 
{
    /**
     * 查询SysCusService1Bi
     * 
     * @param qd SysCusService1Bi主键
     * @return SysCusService1Bi
     */
    public SysCusService1Bi selectSysCusService1BiByQd(String qd);

    /**
     * 查询SysCusService1Bi列表
     * 
     * @param sysCusService1Bi SysCusService1Bi
     * @return SysCusService1Bi集合
     */
    public List<SysCusService1Bi> selectSysCusService1BiList(SysCusService1Bi sysCusService1Bi);

    /**
     * 新增SysCusService1Bi
     * 
     * @param sysCusService1Bi SysCusService1Bi
     * @return 结果
     */
    public int insertSysCusService1Bi(SysCusService1Bi sysCusService1Bi);

    /**
     * 修改SysCusService1Bi
     * 
     * @param sysCusService1Bi SysCusService1Bi
     * @return 结果
     */
    public int updateSysCusService1Bi(SysCusService1Bi sysCusService1Bi);

    /**
     * 删除SysCusService1Bi
     * 
     * @param qd SysCusService1Bi主键
     * @return 结果
     */
    public int deleteSysCusService1BiByQd(String qd);

    /**
     * 批量删除SysCusService1Bi
     * 
     * @param qds 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteSysCusService1BiByQds(String[] qds);

    public int deleteCusService1ByOrderId(@Param("orderId") String orderId);

    public List<Map<String,Object>> selectAreaSummary();

    @Select("${sql}")
    public List<Map<String,Object>> selectSummaryInfo(@Param("sql") String sql);

    public List<Map<String,Object>> selectShzsSummary();

    public List<Map<String,Object>> selectShwtSummary();

    public List<Map<String,Object>> selectShcpSummary();

    public List<Map<String,Object>> selectShlxSummary();

    public List<Map<String,Object>> selectCusServiceList();
}
